SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateData]
    (
      @ID NUMERIC ,
      @Title VARCHAR(50) ,
      @Detail NTEXT
    )
AS 
    UPDATE  dbo.SAP_Knowledge
    SET     Title = @Title ,
            Detail = @Detail
    WHERE   ID = @ID
GO
